CREATE TABLE [dbo].[Country_Names]
(
[COUNTRY] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_COUNTRY] DEFAULT (''),
[MAIL_GROUP] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_MAIL_GROUP] DEFAULT (''),
[ADDRESS_FORMAT] [tinyint] NOT NULL CONSTRAINT [DF_Country_Names_ADDRESS_FORMAT] DEFAULT ((0)),
[VAT_COUNTRY_CODE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_VAT_COUNTRY_CODE] DEFAULT (''),
[INTRASTAT_CODE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_INTRASTAT_CODE] DEFAULT (''),
[USE_CANADA_TAX] [bit] NOT NULL CONSTRAINT [DF_Country_Names_USE_CANADA_TAX] DEFAULT ((0)),
[DEFAULT_SHIPPING_METHOD] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_DEFAULT_SHIPPING_METHOD] DEFAULT (''),
[MIN_VAT_CODE_LEN] [tinyint] NOT NULL CONSTRAINT [DF_Country_Names_MIN_VAT_CODE_LEN] DEFAULT ((0)),
[MAX_VAT_CODE_LEN] [tinyint] NOT NULL CONSTRAINT [DF_Country_Names_MAX_VAT_CODE_LEN] DEFAULT ((0)),
[VAT_CODE_VALID_PROC] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_VAT_CODE_VALID_PROC] DEFAULT (''),
[COUNTRY_CODE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_COUNTRY_CODE] DEFAULT (''),
[ISO_3DIGIT_CODE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Country_Names_ISO_3DIGIT_CODE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Country_Names] ADD CONSTRAINT [PK_Country_Names] PRIMARY KEY CLUSTERED ([COUNTRY]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iCountry_NamesDEFAULT_SHIPPING] ON [dbo].[Country_Names] ([DEFAULT_SHIPPING_METHOD]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Country_Names] TO [IMIS]
GRANT SELECT ON  [dbo].[Country_Names] TO [IMIS]
GRANT INSERT ON  [dbo].[Country_Names] TO [IMIS]
GRANT DELETE ON  [dbo].[Country_Names] TO [IMIS]
GRANT UPDATE ON  [dbo].[Country_Names] TO [IMIS]
GO